How to: Copy styles from another workbook.
Solution:
Open the source and destination workbooks. In the destination workbook, select 'Style...' from the 'Format' menu to display the 'Style' dialog box. Click 'Merge...' and select the source workbook in the 'Merge Styles From' list box.
1) Open the workbook that contains the styles to copy (source).
2) Open the workbook to which to copy the styles (destination).
3) In the destination workbook, select the 'Format' menu and select 'Style...'. (The Style dialog box appears.)
4) Click 'Merge...'. (The Merge Styles dialog box appears.)
the Merge... button
5) Select the source workbook from the 'Merge Styles From' list box.
the Merge Styles From list box
6) Click 'OK'. (The Style dialog box reappears.)
7) If any styles in the two workbooks have the same name but different formats, do one of the following in the displayed message box:
NOTE: This message box only appears once, and the selected action will apply to all the conflicting styles.
a) To replace the styles in the destination workbook, click 'Yes'.
b) To keep the styles in the destination workbook, click 'No'.
c) To cancel the merge, click 'Cancel'.
NOTE: To view all the styles in the destination workbook, click on the down arrow button on the right of the 'Style Name' drop-down list box.
8) Click 'Close' to return to the destination workbook.
